Release 10.1A: OpenEdge Development:
ADM Reference


newQueryString

Returns a new query string to the passed query. The tables in the passed query must match getQueryTables(). Adds column/value pairs to the corresponding buffer’s WHERE clause. Each buffer’s expression is always enclosed in parentheses.

Location: lookup.p

Parameters:

INPUT pcColumns AS CHARACTER

Comma-separated list of column names, of the form table.fieldname.

INPUT pcValues AS CHARACTER

Comma-separated list of the corresponding values.

INPUT pcDataTypes AS CHARACTER

Comma-separated list of the corresponding data type.

INPUT pcOperators AS CHARACTER

Comma-separated list of operators. If a single operator, applies to all columns. If blank, defaults to EQ. Separate alternative string operators with a slash; example: EQ/BEGINS

INPUT pcQueryString AS CHARACTER

A complete, fully-qualified query string matching the queries tables. If "?", use the base query.

INPUT pcAndOr AS CHARACTER

How to relate the new expression to the existing query (for each buffer). Valid values are AND and OR.

Returns: CHARACTER

Notes: This was taken from query.p but changed for lookups to work without an SDO.


Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095